package ultility;

public class Procedure {
	//MEMBER
	//SP_Login(@Account, @Password): return a Member when success or null when fail
	final public static String SQL_SP_LOGIN = "{call SP_Login(?, ?)}";
	
	//SP_Registry(@Account, @Password, @Email): registry new account with default role is candidate
	final public static String SQL_SP_REGISTRY = "{call SP_Registry(?, ?, ?, ?)}";
	
	//SP_ChangeMemberRole(@MemberId, @RoleId): set new role for this account
	final public static String SQL_SP_CHANGE_MEMBER_ROLE = "{call SP_ChangeMemberRole(?, ?)}";
	
	//SP_CheckExistAccount(@Account): check consist of account name - true:exist - false: not exist
	final public static String SQL_SP_CHECK_EXIST_ACCOUNT = "{call SP_CheckExistAccount(?)}";
	
	//SP_CheckExistEmail(@Email): check consist of email - true:exist - false: not exist
	final public static String SQL_SP_CHECK_EXIST_EMAIL = "{call SP_CheckExistEmail(?)}";
	
	//SP_ChangePassword(@MemberId, @Password): change user password
	final public static String SQL_SP_CHANGE_PASSWORD = "{call SP_ChangePassword(?, ?)}";
	
	//WORK
	final public static String SQL_SP_POST = "{call SP_Post()}";
	
	final public static String SQL_SP_WORK_UPDATE = "{call SP_Login(?, ?)}";
	
	final public static String SQL_SP_LOAD_PAGE = "{call SP_LoadPage(?, ?, ?)}";
	
	final public static String SQL_SP_SEARCH = "{call SP_Login(?, ?)}";
	
	final public static String c = "";
	
	final public static String d = "";
	
	final public static String e = "";
}